package com.club.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

@Mapper
public interface ChartMapper {

    @Select("select a.name,count(*) as courseCount from Coach a left join Course b on a.id=b.coach_id group by a.name")
    List<HashMap> chartA();
}
